Note: This statement is named First Recordset Row in the Add Statement dialog box.
Makes the first row in a recordset the active row.
Syntax
FirstRow(Recordset)
Arguments
Argument | Description |
---|---|
Recordset | Recordset name. Must be opened with OpenRecordset or OpenRecordsetQuery. |
Example
rs = OpenRecordset("WysiCorp Bugs (Excel)")
FirstRow(rs)
While Not RecordsetEOF(rs)
PrintLn(GetRowValue(rs, "First Name"))
NextRow(rs)
WEnd